Use BD_SYS_ALMACEN
Go
Create Procedure dbo.GRMaterial_Listar
As
Begin

   Select 
      iCodMat,
      iCodSub,
      vNomMat,
      iCodEstMat,
      iCodUni,
      nCanMat,
      iCodUsu,
      vNomTer,
      dtFecAct
   From GRMaterial a(Nolock)   
   Order By vNomMat
   
End